package com.sai.sql;

public class SqlRubro {
    public static final String SELECT;
    public static final String DELETE;
    public static final String SELECT_ALL;
    public static final String INSERT;
    
    static {
        StringBuilder qryBuilder = new StringBuilder();

        qryBuilder = new StringBuilder();
        qryBuilder.append("SELECT * FROM articulo WHERE nombre = ?");
        SELECT = qryBuilder.toString();
        
        qryBuilder = new StringBuilder();
        qryBuilder.append("SELECT * FROM rubros WHERE idRubro = ?");
        DELETE = qryBuilder.toString();

        qryBuilder = new StringBuilder();
        qryBuilder.append("SELECT * FROM rubros");
        SELECT_ALL = qryBuilder.toString();

        qryBuilder = new StringBuilder();
        qryBuilder.append("INSERT INTO rubros(Parcial,Descripcion,Materia,Profesor) values (?,?,?,?)");
        INSERT = qryBuilder.toString();
     }
}
